Tabela ChemotherapyInvoice

Definicja tabeli ChemotherapyInvoice

Name

ChemotherapyInvoice

Code

ChemotherapyInvoice

Comment

Informacje na temat faktury zakupowej i pozycji w ramach której zostal zakupiony lek


Lista kolumn tabeli ChemotherapyInvoice

Name

Code

ChemotherapyInvoiceID

ChemotherapyInvoiceID

ContractServicePerfID

ContractServicePerfID

TaxPayerID

TaxPayerID

InvoiceNumber

InvoiceNumber

PositionInInvoice

PositionInInvoice

DrugAmount

DrugAmount

InvoiceDT

InvoiceDT


Kolumna ChemotherapyInvoiceID tabeli ChemotherapyInvoice

Definicja kolumny ChemotherapyInvoiceID tabeli ChemotherapyInvoice

Name

ChemotherapyInvoiceID

Code

ChemotherapyInvoiceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractServicePerfID tabeli ChemotherapyInvoice

Definicja kolumny ContractServicePerfID tabeli ChemotherapyInvoice

Name

ContractServicePerfID

Code

ContractServicePerfID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TaxPayerID tabeli ChemotherapyInvoice

Definicja kolumny TaxPayerID tabeli ChemotherapyInvoice

Name

TaxPayerID

Code

TaxPayerID

Data Type

VARCHAR2(13)

Mandatory

Yes

Comment

Nip sprzedajacego


Kolumna InvoiceNumber tabeli ChemotherapyInvoice

Definicja kolumny InvoiceNumber tabeli ChemotherapyInvoice

Name

InvoiceNumber

Code

InvoiceNumber

Data Type

VARCHAR2(25)

Mandatory

Yes

Comment

Numer faktury


Kolumna PositionInInvoice tabeli ChemotherapyInvoice

Definicja kolumny PositionInInvoice tabeli ChemotherapyInvoice

Name

PositionInInvoice

Code

PositionInInvoice

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Numer pozycji na fakturze


Kolumna DrugAmount tabeli ChemotherapyInvoice

Definicja kolumny DrugAmount tabeli ChemotherapyInvoice

Name

DrugAmount

Code

DrugAmount

Data Type

NUMBER(22,10)

Mandatory

No

Comment

losc podanego leku z danej faktury zakupowej


Kolumna InvoiceDT tabeli ChemotherapyInvoice

Definicja kolumny InvoiceDT tabeli ChemotherapyInvoice

Name

InvoiceDT

Code

InvoiceDT

Data Type

DATE

Mandatory

No

Comment

Data wystawienia faktury (faktura nie musi byc zapisana w naszym systemie)


Lista kluczy tabeli ChemotherapyInvoice

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ChemotherapyInvoice

Definicja klucza Identifier_1 tabeli ChemotherapyInvoice

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment